package com.bishe.demo.modules.ticket.dao;

import com.bishe.demo.modules.ticket.entity.Seating;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

/**
 * @Description SeatingDao
 * @Author YHQ
 * @Date 2021/3/30 18:54
 */
@Repository
@Mapper
public interface SeatingDao {
    @Select("SELECT seating_id FROM train_seating AS ts WHERE ts.seating_name = #{seatingName} ")
    Integer getSeatingIdBySeatingName(String seatingName);

    @Select("SELECT seating_name FROM train_seating")
    Seating getSeating();


}
